Creating Visuals and Formatting 14

Step 1: Creating a Visual  


1-      Double click or drag and drop a line and stacked column chart.

2-      Enter Year and Month in the shared axis from DateDim table.

3-     Enter Border into the Column Series from the Border Crossing table.

4-     Enter Crossing PM in the Column Values from Key Measures table.

5-     Enter MoM% and YoY% into the Line Values from Key Measures table.

6-    Enter MoM% and YoY% into the Tooltips.

7-     Format tab under visualization, expand General and set X Position 191, Y-Position 106, Width 495, and Height 306.

Step 1-1: Format the Visual:


1-      Expand X-axis and set Text size 10, turn off the Title, and Turn on the Gridlines with Color #000000

2-      Expand Y-axis and Color #000000, Text Size 10, Title off, Gridlines On, Line color #000000, Show secondary On, Align Zeros On, color #23BEC9, and Text size 12.

3-       Data colors enter YoY% #12239E, MoM% #23BEC9, US-Canada Border #07AFF6, US-Mexico Border   #63472B (Brown)

Step 1-2: Formatting the visual



1-      Turn On the Data Label, Color #2B9299, Value Decimal Places 1, Position Inside Base, Text size 10, Background color # E6E6E6, Turn on Customize series, Drop down US- Canada border Color #07AFF6, US-Mexico Border   #63472B, YoY% #12239E, MoM% #23BEC9, Text size 10,

2-       Expand Shapes – turn on Shade area, Customize Series ON

3-      Turn on Title – Write down the Title of the visual (By Crossing Border), font color #FFFFFF (white), Background color #70BBFF, Alignment Center and Text size 16.

4-       Expand Background- Color # E6E6E6

5-       Border On, Color # E6E6E6

How to create and format visual

https://docs.microsoft.com/en-us/power-bi/visuals/service-getting-started-with-color-formatting-and-axis-properties